home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Fritz: All Fritz
/
All Fritz.zip
/
All Fritz
/
FILES
/
BUSINESS
/
DAYOPRBK.LZH
/
DAYOBE.EXE
/
DAYOPB.DOC
< prev
next >
Wrap
Text File
|
1992-06-08
|
203KB
|
2,706 lines
╔════════════════════════════════════════════════════════════════════════════╗
║ ║
║ ║
║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║
║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║
║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║
║ ║
║ ║
║ ║
║ ████▄ █▄██▄ ███░ ▄███▄ ████░ ║
║ █░ █░ █░ █░ █░ █░ █░ ║
║ ████▀ █▄▄▄█░ █░ █░ █▄▄ ║
║ █░ █░ █▄ █░ █░ █░ ║
║ █░ █░ █░ ███░ ▀███▀ ████░ ║
║ ║
║ ║
║ █▄███▄ ▄███▄ ▄███▄ █░ ▄█░ ║
║ █░ █░ █░ █░ █░ █░ █▄█▀ ║
║ █▀▀▀▀▄ █░ █░ █░ █░ ██▄ ║
║ █░ █░ █░ █░ █░ █░ █░▀█░ ║
║ █▀███▀ ▀███▀ ▀███▀ █░ ▀█░ ║
║ ║
║ ║
║ ║
║ Copyright (c) 1990-92, TJS LAB, PO Box 585366, Orlando, Florida 32858-5366 ║
║ ║
║ ║
║ ║
║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║
║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║
║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║
║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║
║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║
║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║
║ ▀▓▓▓▀ & LAN █████■████▌ O A ║
║ Applications ▐███████████ N R ║
║ ┌─┐ ┌─┐ ███████████▌ S E ║
║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║
║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║
║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║
║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║
║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║
║ █ G ║
║ PO BOX 585366, ORLANDO, FLORIDA 32858-5366 ▄▄▄▄▀ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO Price Book, TJS LAB
■ SOFTWARE SUPPORT POLICY
1. TJS LAB does not support users of unregistered DAYO products with the
exception of installation questions.
2. Support (included with registration) remains in effect for 3 months
after date of registration or upgrade.
3. Support is available through the following methods:
- Phone/Voice Mail: (407) 291-3960/6987
- U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366
- Compuserve Easyplex: 76367,1401
4. Any errors ("bugs or features') in the program will be corrected and
the 'fix' sent promptly (via modem if possible).
DAYO Price Book, TJS LAB Page: 1
Table of Contents
Page Subject
──── ───────────────────────────────────────
3 ............... INTRODUCTION
4 ............... COPYRIGHT/LICENSE
4 ............... DISCLAIMER
4 ............... REQUIREMENTS
4 ............... SETUP
5 ............... MAIN MENU
5 ............... PASSWORD/NAME
6 ............... SPECIAL PRICING
6 ............... FIXED PRICE EXAMPLE
6,7 ............... SPECIAL PRICING SCREEN
8 ............... CUSTOMERS
9 ............... PB MARGIN & PB LIST
10 ............... CONFIGURATION
10 ............... COMPANY NAME
11 ............... COMPANY ADDRESS
11 ............... COMPANY TELEPHONE
11 ............... DEFAULT LOWEST MARGIN
11 ............... ALLOW PBM/PBL EDIT
12 ............... INVENTORY DATABASE LOCATION/DIRECTORY
12 ............... CUSTOMER DATABASE LOCATION/DIRECTORY
12 ............... REPORT PRINTER TYPE
12 ............... REPORT PRINTER PORT
13 ............... VISUAL INDEXING
13 ............... AUTOMATIC DAILY INDEXING
13 ............... COLOR MONITOR
14 ............... COLOR INTENSITY
14 ............... REPORTS
15 ............... STORE USE PRICE BOOK
15 ............... CUSTOMER RETAIL PRICE BOOK
16 ............... CUSTOMER PRICE BOOK
16 ............... CUSTOMER SPECIFIC PRICE BOOK
17 ............... SPECIAL PRICING REPORT
17 ............... ADDRESS LABELS
18 ............... DATABASE SUMMARY REPORT
18 ............... CONFIGURATION STATUS REPORT
DAYO Price Book, TJS LAB Page: 2
Table of Contents
Page Subject
──── ───────────────────────────────────────
19 ............... PRINTER DRIVER (SETUP)
19 ............... PRINTER DRIVER OPTIONS
20 ............... CHANGE DEFAULT PRINTER
21 ............... FULL SCREEN EDIT - F2
21 ............... PRINTER DRIVER DATABASE FIELD DEFINITIONS
22 ............... MISCELLANEOUS ROUTINES
23 ............... MISC Routines Menu
23 ............... APPEND FROM
25 ............... BROWSE DATABASES
27 ............... COPY (.DBF) TO
29 ............... CREATE DATABASE
32 ............... DELETE RECORDS
32 ............... ERASE FILE
32 ............... EXIT TO DOS
33 ............... INDEX A DATABASE
34 ............... LIST FIELDS
37 ............... MODIFY DATABASE
38 ............... PACK DATABASE
39 ............... RECALL RECORDS
39 ............... RETURN TO MENU
39 ............... RUN (DOS COMMAND)
40 ............... SIMPLE EDITOR
41 ............... SORT DATABASE
42 ............... TYPE (PRINT) FILE
43 ............... ZAP DATABASE
45 ............... HELP SCREENS
46 ............... EXPANDED HELP
47 ............... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
48 ............... VIEW DOCUMENTATION ONSCREEN
49 ............... DATABASE STRUCTURE
51 ............... DATA DICTIONARY
52 ............... DAYO PB MAINTENANCE & QUIRKS
54 ............... TJS LAB, CUSTOM CODING
DAYO Price Book, TJS LAB Page: 3
■ INTRODUCTION
DAYO Price Book is a system of creating and maintaining specialized
pricing for your customer/clients. Special printouts (Price Books/Catalogs),
can be printed to a standard printer, or to a Hewlett Packard (tm) Laserjet
or compatible. It requires the presence of DAYO Inventory and DAYO POS
(Point of Sale) programs/databases.
Customers are invoiced (with DAYO POS), using the price in the inventory
database (INV.DBF), or with one of the special Price Book methods:
Fixed - Fixed Price for a Unique Item + Customer (1st Priority)
Margin - 'Cost Plus' (2nd Priority)
List Discount - Discount off the List/Retail Price (3rd Priority)
This application is multiuser when run a PC based LAN/Network.
Some of the DAYO Price Book highlights are:
Multiuser ie: Novell (tm)
Data Entry Validation
Databases are dBase (tm) compatible
HP Laser Price Books/Catalogs
Customer Bill To/Mailing Address Labels
Special Customer Pricing
Margin
Discount Off List
Fixed
Configurable Options
Passwords (with DAYO Passwords)
Reports
Relational Database
Other DAYO Products:
DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving
DAYO POS Point of Sales (Billing & Invoicing)
DAYO Quotes Sales Quoting System
DAYO AR Accounts Receivable
DAYO AP Accounts Payable
DAYO BO Back Orders
DAYO EOP End Of Period Posting
DAYO Passwords Password protect your DAYO system
DAYO Smart Reports A variety of reports pertaining to the above modules
DAYOX Network/LAN Index Maintenance Utility
DAYO Price Book, TJS LAB Page: 4
■ COPYRIGHT/LICENSE
This manual and software is copyrighted with all rights reserved by
TJS LAB. No copying of this manual or software is authorized without
the prior written consent of TJS LAB. An exception to this rule is the
making of backup copies of registered software disks. No RESALE of any part
of the source codes is authorized without the prior written consent of
TJS LAB. TJS LAB retains all rights to DAYO Price Book software,
documentation, and source codes.
■ DISCLAIMER
No warrant is made that this software will work in all environments,
or with all resident programs and hardware configurations. TJS LAB has
tested this software in many environments and found it to perform as
expected, however, this software is licensed "AS IS".
TJS LAB will not be liable for any damage done to your data, hardware
and/or software systems as a result of using DAYO Price Book.
■ REQUIREMENTS ***
IBM or Compatible CPU
640K memory
* DOS 3.3 or above
Hard Disk
Presence of DAYO Inventory & DAYO POS
■ SETUP
To setup DAYO Price Book, copy the contents of the DAYO Price Book floppy
disks into a directory on your hard disk (ie: \DAYOPB). When you run
DAYOPB for the first time, it will create all the database, index, and
configuration files it requires for operation. If you are using other DAYO
modules, be sure to enter the location of these databases into the DAYO Price
Book configuration. Type and enter 'DAYOB' at the DOS prompt to run the
program (ie: C:\DAYOB ).
DAYO Price Book, TJS LAB Page: 5
■ MAIN MENU
After a few moments and possibly a reindex, the main menu will appear:
DAYO Price Books Version 4.00 TJS LAB, Inc. ┌─────[June 1992]────┐
Copyright (c) 1989-1992, All Rights Reserved │S M T W T F S │
╓────────────────────╖ ██▄████░ ▄███▄ ██░ ██░ ██████░ ├────────────────────┤
║ 1 SPECIAL PRICING ║ ██░ ██░ ██░██░ ██░ ██░ ██░ ██░ │ 1 2 3 4 5 6│
╟────────────────────╢ ██░ ██░ ██░██░ ▀████▀ ██░ ██░ │ 7 8 9 10 11 12 13│
║ 2 CUSTOMERS ║ ██░ ██░ ██▀▀▀██░ ▀██▀ ██░ ██░ │14 15 16 17 18 19 20│
╟────────────────────╢ ██░ ██░ ██░ ██░ ██░ ██░ ██░ │21 22 23 24 25 26 27│
║ 3 CONFIGURATION ║ █▀█████░ ██░ ██░ ██░ ██████░ │28 29 30 │
╟────────────────────╢ │ │
║ 4 REPORTS ║ ████▄ █▄██▄ ███░ ▄███▄ ████░ └────────────────────┘
╟────────────────────╢ █░ █░ █░ █░ █░ █░ █░
║ 5 MISC ROUTINES ║ ████▀ █▄▄▄█░ █░ █░ █▄▄
╟────────────────────╢ █░ █░ █▄ █░ █░ █░
║ 6 EXIT ║ █░ █░ █░ ███░ ▀███▀ ████░
╚════════════════════╝
Select Option █▄███▄ ▄███▄ ▄███▄ █░ ▄█░
█░ █░ █░ █░ █░ █░ █▄█▀
█▀▀▀▀▄ █░ █░ █░ █░ ██▄
█░ █░ █░ █░ █░ █░ █░▀█░
█▀███▀ ▀███▀ ▀███▀ █░ ▀█░ [ Alt F9 To Reindex ]
DAYO Price Book Database Statistics Database # Records Bytes
Special Pricing Database PB.DBF 0 131
Inventory Database INV.DBF 228 87658
Customer Database CUSTOMER.DBF 4 3375
View-Adjust-Create Special Price Book Prices
The left side of the screen is the actual main menu. The calendar and
logos are just 'art'. The DAYO Price Book statistics box (bottom), contains
the number of records and size (in bytes) of the databases used by DAYO
Price Books.
■ PASSWORD/NAME
From the main menu you can enter any of the modules, but not until you
enter your name (or password if using DAYO Password):
┌────────────────────────────────────────────────────────────────────────────┐
│┌──────────────────────────────────────────────────────────────────────────┐│
││ Enter Your Name: TOM JOHNSON ││
│└──────────────────────────────────────────────────────────────────────────┘│
└────────────────────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 6
■ SPECIAL PRICING
The SPECIAL PRICING menu option is the module that allows you to create
FIXED prices for specific customers. This is accomplished by creating a
database record (for PB.DBF), that contains the ITEM number, the PRICE, and
the CUSTOMER number. DAYO POS 'looks' into this file when displaying this
item information and when computing prices for the invoice.
The DAYO POS priority for determining the price of an item goes FIRST to
FIXED prices in the database PB.DBF.
■ FIXED PRICE EXAMPLE
Example:
You have a customer with a customer number of '1000' and want to insure
that he is always charged a FIXED price of $99.00 for item number '202020'.
Solution:
Find the customer number in this screen by pressing 'F5', or add the
customer number to this file by pressing 'Ctrl N' (select from a browse of
all customers). Note you can not add a customer to the database PB.DBF if
it already exists there...
Find and select item '202020' from the inventory (you may need to press
'F3').
You will next be prompted to enter 99.00 as the FIXED price.
Thats it! Henceforth and forever more (or until you change it), the
default price for item '202020' will be $99.00.
■ SPECIAL PRICING SCREEN
The SPECIAL PRICING SCREEN is a browse of the Price Book database
(PB.DBF). From it you can view or edit existing FIXED prices, or add to the
database.
DAYO Price Book, TJS LAB Page: 7
DAYO Price Books Version 4.0 TJS LAB PRICE BOOK ┌───[February 1991]──┐
╔════════════════════════════════════════════════════════════════════════════╗
║ BILL TO CUSTOMER SALESPER DATE LASTDATE ║
║ Harpers Flower Shop 32005 TA 01/01/90 12/12/89 ║
║ TYPE CLASS TERMS SALES PB MARGIN PB LIST ║
║ REG FFG NET 30 24350.31 25.000 0.000 ║
║ Item Vendor Item Vendor Description Type ║
║ JAR-1 AJ-123456 ACME JAR Sample Item Description XXX ║
║ Onhand OnOrder Cost Retail Price Adj. Price PB Method ║
║ 100 0 99.00 199.99 149.99 132.00 PBS 25.000║
╚═════════════[ Browse the Price Book Special Prices Database ]══════════════╝
CUSTOMER ITEM PRICE
──────────────────────────────╥──────────────╥────────────────────────────────
32005 ║ ALPHAJAR4 ║ 237.37
32005 ║ DELTAJAR1 ║ 106.00
32005 ║ JAR-1 ║ 111.00
32005 ║ JAR-3 ║ 116.00
32005 ║ JAR-4 ║ 132.00
32005 ║ JAR-4 ║ 126.27
32005 ║ JAR-5.1 ║ 131.31
53445 ║ JAR-67 ║ 136.36
Esc (Exit) F1 (Help) F2 (Edit) F3 (Add From Inventory)
Ctrl N (Add New Customer) Ctrl U (Delete/Recall)
Find: F5 (Customer Number) F6 (Customer+Item) F7 (Item)
19/70
The top of the SPECIAL PRICING screen contains key information about the
currently highlighted customer. Below that is key information about the item
you have at the FIXED price. Note the number under the 'Method' header is the
margin value ('cost plus'), of the FIXED price. The center of the screen
contains the Price Book records. There are only 3 fields in the DAYO Price
Book database: CUSTOMER, ITEM, and PRICE.
You can edit the records from the browse screen, or by pressing 'F2' to
bring up a full screen edit option...
Pressing 'F3' will bring up another browse screen containing the
inventory database (INV.DBF), allowing you to find and select items to be
added to the currently highlighted customers 'collection' of FIXED prices.
╚════════────[ Select The Inventory ITEM To Be Added to PB.DBF ]──═══════════╝
ITEM DESC ONHAND ONORDER BO
──────────────╥────────────────────────────────╥─────────╥─────────╥──────────
JAR-3 ║ RED JAR ║ 0 ║ 30 ║ 20
JAR-54 ║ GREEN JAR ║ 100 ║ 0 ║ 0
JAR-678 ║ MAGENTA JAR ║ 100 ║ 0 ║ 0
JAR-679 ║ PURPLE JAR ║ 73 ║ 0 ║ 0
JAR-797 ║ CRIMSON JAR ║ 100 ║ 0 ║ 0
JAR-79-9 ║ LAVENDAR JAR ║ 100 ║ 0 ║ 0
JAR-89-898 ║ ORANGE JAR ║ 100 ║ 0 ║ 0
DAYO Price Book, TJS LAB Page: 8
If you do not have a Price Book record for a customer, the you need to
press 'Ctrl N' to bring up a browse of all the customers. Find the customer
you wish to add for the first time, and then press Enter/Return. Note, the
customer can not be added to the Price Book database if it already exists
there.
╚════════─────[ Select The CUSTOMER To Receive Special Pricing ]──═══════════╝
CUSTOMER NAME ATTN
───────────╥────────────────────────────────╥─────────────────────────────────
234243 ║ ARLIE JAMES ║
345654 ║ ARM SCHOOL OF LAW ║
499999 ║ KELLY SCHOOL OF COSMETOLOGY ║ Newton Cristian
567999 ║ ARNOLD PICTURES ║
639999 ║ UNIVERSAL STUDIOS ║
687239 ║ M3M LABELS ║ Aster
789999 ║ WATCHER LIZ ║ JUSTIN
999567 ║ MORGAN ENTERPRISES, INC ║ JOE
║ ║
To remove items from the Price Book database, you need to delete them
(press 'Ctrl U'), then PACK the Price Book database (PB.DBF) utilizing the
MISC Routines. You will then need to reindex PB.DBF to insure the indexes are
corrected.
■ CUSTOMERS
All customers records can be viewed (but not edited/altered) from the
CUSTOMERS browse screen (option 2 from the main menu). To edit the customer
database (CUSTOMER.DBF) requires the use of BROWSE DATABASE option in the
MISC Routines. Note, it is recommended that you do all your customer edits
with DAYO AR (Account Receivable & Customers).
DAYO Price Book, TJS LAB Page: 9
The top of the screen contains key information about the customer,
including the default SPECIAL PRICING method of pricing, ie:
DAYO Price Books Version 4.0 TJS LAB CUSTOMER ┌───[February 1991]──┐
╔════════════════════════════════════════════════════════════════════════════╗
║ BILL TO CUSTOMER SALESPER DATE LASTDATE ║
║ ARNOLD PICTURES 567999 RT 01/01/90 12/23/89 ║
║ TYPE CLASS TERMS SALES PB MARGIN PB LIST ║
║ REG COD 53243.00 0.000 10.000 ║
╚════════════════[ Browse the Customer Database (View Only) ]════════════════╝
CUSTOMER NAME ATTN
───────────╥────────────────────────────────╥─────────────────────────────────
234243 ║ ARLIE JAMES ║
345654 ║ ARM SCHOOL OF LAW ║
499999 ║ KELLY SCHOOL OF COSMETOLOGY ║ Newton Cristian
567999 ║ ARNOLD PICTURES ║
639999 ║ UNIVERSAL STUDIOS ║
687239 ║ M3M LABELS ║ Aster
789999 ║ WATCHER LIZ ║ JUSTIN
999567 ║ MORGAN ENTERPRISES, INC ║ JOE
║ ║
Esc (Exit) F1 (Help) F2 (Edit PBM/PBL)
Find: F5 (Customer Number) F6 (Name) F7 (Ship To Name) F8 (Phone)
6/8
■ PB MARGIN & PB LIST
Of special interest are the 'PB MARGIN', and 'PB LIST' entries/fields.
The PB MARGIN is the margin value ('cost plus'), and the PB LIST is the
discount off list/retail that you wish to apply to all items for the
customer. The ability to edit these entries/fields is accomplished by
pressing 'F2'. Note, this capability can be 'turned off' in the CONFIGURATION
menu option.
DAYO POS pricing priority goes first to any FIXED price, but if no FIXED
price record can be found in the Price Book database (PB.DBF), DAYO POS will
'consider' utilizing the PB MARGIN or PB LIST entries/fields in price
determination. Priority goes to the PB MARGIN (PBM) field if not equal to
zero, then to the PB LIST (PBL) field if it is not equal to zero. If both
fields are empty (equal to zero), then the price in the inventory database
(INV.DBF) will be used.
DAYO Price Book, TJS LAB Page: 10
If you have DAYO Price Book configured to allow the editing of the
PBM/PBL fields (default is to allow editing...), press 'F2' to bring up the
following prompt box:
╔═════════════════════════════════════════════════════════════════════╗
║ PBM - Price Book Margin PBL - Price Book List ║
║ The Margin takes priority over the List Discount when the ║
║ Margin is not equal to 0. That means that if you want the ║
║ PBL field to determine the price, then make sure PBM=0... ║
║ Note, use 'whole' numbers to determine the values. ║
║ ie: To make a 10 point mark up from cost, set PBM=10.000 ║
║ To make a 25.5% List Discount, set PBL=25.500 ║
║ ║
║ Price Book Margin: 10.000 ║
║ Price Book List Discount: 0.000 ║
╚═════════════════════════════════════════════════════════════════════╝
■ CONFIGURATION
Press '3' or select the CONFIGURATION option from the main menu to bring
up the CONFIGURATION menu. There are 13 DAYO Price Book configuration
settings. All of which can be seen in the CONFIGURATION menu that appears on
the left of the screen, ie:
╔═════════════════════════╗
║ CONFIGURATION ║
╟─────────────────────────╢
║ Company Name ║
║ Company Address ║
║ Company Telephone ║
║ Default Lowest Margin ║
║ Allow PBM/PBL Edit ║
║ Inventory Location ║
║ Customer Location ║
║ Report Printer Type ║
║ Report Printer Port ║
║ Visual Indexing ║
║ Auto Daily Indexing ║
║ Color ║
║ High Intensity ║
╟─────────────────────────╢
║ Select Option ║
╚═════════════════════════╝
■ COMPANY NAME
┌──────────────────────────────[ COMPANY NAME ]──────────────────────────────┐
│ Enter Your Company Name: YOUR COMPANY NAME, INC │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 11
■ COMPANY ADDRESS
┌────────────────────────────[ COMPANY ADDRESS ]─────────────────────────────┐
│ Address Line 1: Attn: Sales │
│ Address Line 2: P.O. BOX 5555 │
│ City, State ZIP: ANYCITY, ST 55555-5555 │
└────────────────────────────────────────────────────────────────────────────┘
■ COMPANY TELEPHONE
┌───────────────────────────[ COMPANY TELEPHONE ]────────────────────────────┐
│ Enter Your Company Telephone: 800-555-5555 │
└────────────────────────────────────────────────────────────────────────────┘
■ DEFAULT LOWEST MARGIN
┌─────────────────────────[ DEFAULT LOWEST MARGIN ]──────────────────────────┐
│ This margin value determines the lowest price that your users can make │
│ while in the DAYO POS program. The default is 1, which means that the │
│ price can not be less than the cost. │
│ │
│ Enter The Margin: 1.000 │
└────────────────────────────────────────────────────────────────────────────┘
■ ALLOW PBM/PBL EDIT
┌───────────────────────────[ ALLOW PBM/PBL EDIT ]───────────────────────────┐
│ When this setting is set to Y (Yes), the users of DAYO PB can edit │
│ (change the value) of the PBM and PBL fields in the customer │
│ database (CUSTOMER.DBF). Default is to allow - Y (Yes). │
│ │
│ Allow PBM/PBL Edit? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 12
■ INVENTORY DATABASE LOCATION/DIRECTORY
┌──────────────────────[ INVENTORY LOCATION/DIRECTORY ]──────────────────────┐
│ The location of the DAYO Inventory (INV.DBF) does not have to be in │
│ the same drive/directory as DAYO PB. If you have installed DAYO Inventory │
│ into a different directory, you need to tell DAYO PB where to find the │
│ inventory database (INV.DBF). Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYO\ │
│ The drive designation is optional (if same as DAYO PB). │
│ │
│ Enter Location: \DAYOINV\ │
└────────────────────────────────────────────────────────────────────────────┘
■ CUSTOMER DATABASE LOCATION/DIRECTORY
┌──────────────────[ CUSTOMER DATABASE LOCATION/DIRECTORY ]──────────────────┐
│ The location of the DAYO Customer file (CUSTOMER.DBF) does not have to be │
│ in the same drive/directory as DAYO PB. If you have installed the DAYO │
│ Customer Database (CUSTOMER.DBF), into a different directory, you need │
│ to tell DAYO PB where to find it. Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYO\ │
│ The drive designation is optional (if same as DAYO PB). │
│ │
│ Enter Location: \DAYOPB\ │
└────────────────────────────────────────────────────────────────────────────┘
■ REPORT PRINTER TYPE
┌──────────────────────────[ REPORT PRINTER TYPE ]───────────────────────────┐
│ Routine reports are printed according to this selection. │
│ The STANDARD printer type is a Epson/IBM Proprinter printer. │
│ The LASER printer type is a Hewlett Packard Laser compatible printer. │
│ Special Laser codes are sent to the LASER option. │
│ │
│ Enter Your Report Printer Type -> STANDARD │
│ LASER │
└────────────────────────────────────────────────────────────────────────────┘
■ REPORT PRINTER PORT
┌──────────────────────────[ REPORT PRINTER PORT ]───────────────────────────┐
│ Enter Your Report Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 13
■ VISUAL INDEXING
┌────────────────────────────[ VISUAL INDEXING ]─────────────────────────────┐
│ If you desire to see a progress graph each time your indexes are │
│ created, then select Y (YES). Note, the process can slow the indexing │
│ routine down; especially with larger databases. │
│ │
│ Do you wish to have Visual Indexing? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
Example of a 'Visual Indexing Graph':
┌──────────────────────────────────────────────────────────┐
│ Database Name: PB.DBF │
│ Index Name: PB.NTX │
│ Number of Records: 70 │
│ ┌──────────────────────────────────────────────────┐ │
│ │████████████████████████████ │ │
│ └──────────────────────────────────────────────────┘ │
│ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │
└──────────────────────────────────────────────────────────┘
■ AUTOMATIC DAILY INDEXING
┌────────────────────────[ AUTOMATIC DAILY INDEXING ]────────────────────────┐
│ If this option is set to Y (YES), then all DAYO Indexes accessed by │
│ DAYO PB will be recreated once daily. This will occur when the first │
│ DAYO PB program is run. The default is to recreate all the indexes. │
│ │
│ Recreate all DAYO PB Indexes? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ COLOR MONITOR
┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐
│ If you have a color monitor and wish to display colors, then select Y, │
│ (YES), else select N (NO) for monochrome and others. │
│ The default is color, low intensity │
│ │
│ Do you have a color monitor? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 14
■ COLOR INTENSITY
┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐
│ Intensity is only applicable with color set to Y. │
│ It will make your colors brighter... │
│ │
│ Set Color Intensity On? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ REPORTS
Perhaps the greatest feature of DAYO Price Books is its ability to print
a wide variety of price books (catalogs). If you have an HP Laserjet (tm)
printer, you get a special bonus. DAYO Price Books print to either a standard
printer or to a HP Laserjet compatible printer, but the laser version is
complete with lines, shading and different fonts/characters.
The REPORTS menu selection (from the main menu), brings up the following
screen:
╔═════════════════════════════╗
║ DAYO PRICE BOOK REPORTS ║
║ Store Use Price Book ║
║ Customer Retail Price Book ║
║ Customer Price Book ║
║ Specific Customer Price Book║
║ Special Prices Report ║
║ Customer Address Labels ║
║ Database Status ║
║ Config Status ║
║ SELECT REPORT ║
╚═════════════════════════════╝
DAYO Price Book, TJS LAB Page: 15
■ STORE USE PRICE BOOK
╔═══[ STORE USE PRICE BOOK ]════════════════════════════╗
║The Store Use Price Book is a printout of the ENTIRE ║
║inventory, or all for a given VENDOR, TYPE, CLASS, ║
║or LOCATION. The price book prints at a column width ║
║of 132, and at 6 lines per inch (6LPI). The following ║
║fields are printed on the Store Use Price Book: ║
║ ITEM DESC ONHAND ONORDER COST PRICE RETAIL ║
║ VENDOR VENDITEM TYPE CLASS UNIT ║
║Select Price Book -> VENDOR ║
║Enter Vendor Code: ABC ║
║Select Index -> VENDOR ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║Enter File Name: VENDOR.TXT ║
║Enter Report Title: TEST ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
■ CUSTOMER RETAIL PRICE BOOK
╔═══[ CUSTOMER RETAIL PRICE BOOK ]══════════════════════╗
║This report is given to the customer. ║
║It shows the RETAIL field as the price. ║
║The Customer Retail Price Book is a printout of the ║
║ENTIRE inventory, or all for a given VENDOR, TYPE, ║
║or CLASS. The price book prints at a column width ║
║of 132, and at 6 lines per inch (6LPI). The following ║
║fields are printed on the Retail Price Book: ║
║ ITEM DESC RETAIL VENDOR ║
║ VENDITEM TYPE CLASS UNIT ║
║ ║
║Select Option -> Entire Inventory ║
║ ║
║ ║
║ ║
║Select Index -> DESC ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: RETAIL.TXT ║
║ ║
║Enter Report Title: TEST 2 ║
╚═══════════════════════════════════════════════════════╝
DAYO Price Book, TJS LAB Page: 16
■ CUSTOMER PRICE BOOK
╔═══[ CUSTOMER PRICE BOOK ]═════════════════════════════╗
║This report is given to the customer. ║
║It shows the PRICE field (not RETAIL), as the price. ║
║The Customer Price Book is a printout of the ENTIRE ║
║inventory, or all for a given VENDOR, TYPE, or CLASS. ║
║The price book prints at a column width of 132, and ║
║at 6 lines per inch (6LPI). The following fields are ║
║printed on the Price Book: ║
║ ITEM DESC PRICE VENDOR ║
║ VENDITEM TYPE CLASS UNIT ║
║ ║
║Select Option -> Entire Inventory ║
║ ║
║ ║
║Select Index -> DESC ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: PB.TXT ║
║ ║
║Enter Report Title: TEST 3 ║
╚═══════════════════════════════════════════════════════╝
■ CUSTOMER SPECIFIC PRICE BOOK
╔═══[ CUSTOMER SPECIFIC PRICE BOOK ]════════════════════╗
║This report is given to a specific customer. ║
║It shows either the PRICE or RETAIL field as the price.║
║The Customer Specific Price Book is a printout of the ║
║ENTIRE inventory, or all for a given VENDOR, TYPE, ║
║or CLASS. The price book prints at a column width ║
║of 132, and at 6 lines per inch (6LPI). The following ║
║fields are printed on the Retail Price Book: ║
║ ITEM DESC RETAIL or PRICE VENDOR ║
║ VENDITEM TYPE CLASS UNIT ║
║ ║
║Enter Customer Number: 1 ║
║Select Option -> Price = PRICE ║
║Select Option -> Entire Inventory ║
║ ║
║Select Index -> VENDOR ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: SPECIFIC.TXT ║
║ ║
║Enter Report Title: TEST 4 ║
╚═══════════════════════════════════════════════════════╝
DAYO Price Book, TJS LAB Page: 17
■ SPECIAL PRICING REPORT
╔═══[ SPECIAL PRICING REPORT ]══════════════════════════╗
║This report print out only those items found in the ║
║Special Prices Database (PB.DBF). This report has many ║
║uses, but should be used primarily as an audit tool to ║
║maintain the special prices (ie, keep them above cost).║
║The report prints out all 'costs/prices' along with ║
║the margin and list discount values. Special symbols ║
║are printed aside items with a possible price problem. ║
║The price book prints at a column width of 132, and at ║
║6 lines per inch (6LPI). ║
║ ║
║Select Index -> CUSTOMER ║
║ ║
║Eject after each customer? (Y/N) ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║Enter File Name: SPECIAL.TXT ║
║Enter Report Title: TEST 5 ║
║ ║
║ ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
■ ADDRESS LABELS
╔═══════════════════════════════════════════════════════╗
║Use this option to print the Customer BILL TO address ║
║Labels. The Address Label is the standard size of ║
║ 3.5x15/16, 6LPI, and contains the following fields: ║
║ NAME ADDR1 ADDR2 ║
║ CITY STATE ZIP ║
║ ║
║ ┌──────────────────────────────┐ ║
║ │STACY MORGAN │ ║
║ │P.O. Box 585 │ ║
║ │ │ ║
║ │Lancaster, PA │ ║
║ │55555 │ ║
║ ╘══════════════════════════════╛ ║
║ CUSTOMER ║
║Select Customer -> 567999 ║
║ 639999 ║
║ 687239 ║
║ 789999 ║
║ 999567 ║
║Esc (Exit) Enter/Return (Print) F5/F6/F7/F8 (Find) ║
╚═══════════════════════════════════════════════════════╝
DAYO Price Book, TJS LAB Page: 18
■ DATABASE SUMMARY REPORT
╔═══════════════════════════════════════════════════════╗
║The Database Summary Report lists the DAYO Price Book ║
║databases with their current fields, sizes and number ║
║of records. Index files included. Not a Report Form. ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
■ CONFIGURATION STATUS REPORT
╔═══════════════════════════════════════════════════════╗
║The Configuration Status Settings Report lists all of ║
║configuration settings (found in file DAYOPB.CFG). ║
║This is Not a Report Form. ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
DAYO Price Book, TJS LAB Page: 19
■ PRINTER DRIVER (SETUP)
This routine was added to preclude you from having to get out of your
seat to change (mess with) the printer to get it to print correctly.
The most important printer selections (ie: font size, lines per inch,
orientation, ...) are made easy to evoke.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
║ ║
║ Select Option -> Eject ║
║ Line feed ║
║ Normal Size ║
║ Use this routine to set your Small/Condensed ║
║ printer up with one or more Bold On ║
║ of the setup strings and Bold Off ║
║ commands listed to the right. 6 Lines per Inch ║
║ 8 Lines per Inch ║
║ Select the 'Change Printer Print Landscape (Laser Only) ║
║ Default' option to change Print Portrait (Laser Only) ║
║ printer types. Reset Printer ║
║ Current printer is set to: Print Special String 1 ║
║ Okidata Print Special String 2 ║
║ Print Special String 3 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
■ PRINTER DRIVER OPTIONS
There are 18 printer driver options to select from. The last option is
to set the default printer, and the next to last is a 'SHELL' function that
runs a DOS command or program. The remainder are strings/codes that are sent
to the printer.
Eject Print Portrait (Laser Only)
Line feed Reset Printer
Normal Size Print Special String 1
Small/Condensed Print Special String 2
Bold On Print Special String 3
Bold Off Print Special String 4
6 Lines per Inch Print Special String 5
8 Lines per Inch Run DOS Command/Program
Print Landscape (Laser Only) Change Default Printer
DAYO Price Book, TJS LAB Page: 20
■ CHANGE DEFAULT PRINTER
The last option is to change/set the default printer. This printer
driver routine comes with 4 default printer types, Epson, HP Laser, Star,
and Okidata.
You can add (Ctrl N) as many as you want.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ Current Default Printer is set to: Okidata ║
╟────────────────────────────────────────────────────────────────────────────╢
║ NAME LINEFEED ║
║─────────────────────────────────────╥──────────────────────────────────────║
║ Epson & Compatibles ║ CHR(10) ║
║ HP Laser & Compatibles ║ CHR(10) ║
║ Star Micro Gemini ║ CHR(10) ║
║ Okidata ║ CHR(10) ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add)
1/4
DAYO Price Book, TJS LAB Page: 21
■ FULL SCREEN EDIT - F2
When entering the printer codes, the string must be in the valid format
or it will not be printed later when requested...
┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐
│ NAME: Epson & Compatibles │
│ LINEFEED: CHR(10) │
│ NORMAL: CHR(27)+CHR(18) │
│ SMALL: CHR(27)+CHR(15) │
│ BOLDON: CHR(27)+CHR(69) │
│ BOLDOFF: CHR(27)+CHR(70) │
│ _6LPI: CHR(27)+CHR(50) │
│ _8LPI: CHR(27)+CHR(48) │
│ PORTRAIT: │
│ LANDSCAPE: │
│ RESET: CHR(27)+CHR(64) │
│ SPEC_STR1: │
│ SPEC_STR2: │
│ SPEC_STR3: │
│ SPEC_STR4: │
│ SPEC_STR5: │
│ RUN_CMD: │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
■ PRINTER DRIVER DATABASE FIELD DEFINITIONS
NAME - Name of printer. Type in anything you wish here
LINEFEED - Code to advance printer one line
NORMAL - Normal font/character size
SMALL - Small font/character size
BOLDON - Bold/Emphasized
BOLDOFF - Bold/Emphasized off
_6LPI - Code to set printer to print 6 lines per inch
_8LPI - Code to set printer to print 8 lines per inch
PORTRAIT - Code to set laser printer to print upright (normal)
LANDSCAPE - Code to set laser printer to print sideways
RESET - Reset printer code
SPEC_STR1 - Any special printer string, ie: print double, skip perforation,
SPEC_STR2 - print very tiny, ...
SPEC_STR3 - "
SPEC_STR4 - "
SPEC_STR5 - "
RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ...
DAYO Price Book, TJS LAB Page: 22
■ MISCELLANEOUS ROUTINES
- The MISC routines is a collection of 17 very useful Database Management
Routines. These routines provide you with the 'ability to do whatever was
left out of the rest of the program...'. These routines were modeled after
dBase (tm) III+/IV functions. Familiarity with dBase will help with the
understanding and execution of these routines.
USE WITH CAUTION!
YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES
YOU CAN ALSO MESS THINGS UP PERMANENTLY!
■ MISC Routines Menu:
DAYO Price Books Version 4.00 TJS LAB, Inc. ┌─────[June 1992]────┐
╔════════════════════╗92, All Rights Reserved │S M T W T F S │
║ MISC ROUTINES ║ ██▄████░ ▄███▄ ██░ ██░ ██████░├────────────────────┤
╟────────────────────╢╔═════════════════════════════════════════════════════╗│
║ APPEND FROM ║║ This menu option provides you with a multitude of ║│
║ BROWSE DATABASES ║║ database management tools and functions, but also ║│
║ COPY (.DBF) TO ║║ can be a source of significant problems! ║│
║ CREATE DATABASE ║║ ║│
║ DELETE RECORDS ║║ Miscellaneous Routines was provided to give you a ║│
║ ERASE FILE ║║ 'back door' to DAYO, but if used incorrectly, it ║┘
║ EXIT TO DOS ║║ can damage or destroy your data! ║
║ INDEX A DATABASE ║║ ║
║ LIST FIELDS ║║ Adding records to databases, packing, appending, ║
║ PACK DATABASE ║║ editing records and modify databases can ║
║ MODIFY DATABASE ║║ corrupt the indexes related to the database(s)! ║
║ RECALL RECORDS ║║ You must know to reindex (Alt F9) if you do any ║
║ RETURN TO MENU ║║ of these operations... ║
║ RUN (DOS COMMAND) ║║ ║
║ SIMPLE EDITOR ║║ When modifying a database, the rule is to NEVER ║
║ SORT DATABASE ║║ change an existing field; only to add new fields...║
║ TYPE (PRINT) FILE ║║ ║
║ ZAP DATABASE ║║ Remember that 'ZAP' means to remove (permanently) ║
╟────────────────────╢║ all records in the selected database! ║
║ Select Option ║╚═════════════════════════════════════════════════════╝
╚════════════════════╝
DAYO Price Book, TJS LAB Page: 23
■ APPEND FROM
- Used to copy records from one database into another database, or to create
records from ASCII files (SDF or DELIMITED).
- The Initial Screen will prompt you to enter the file name of the database
you are to append/copy the data into. At this point, you can either type in
the name of the target database, or ...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
└────────────────────────────────────────────────────────────────────────────┘
- If it exists in the current directory, press enter on an empty prompt to
display all databases to select from.
┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │INVENT.DBF │ 375 │ 09/16/89 │ │
│ │AR.DBF │ 7219 │ 09/16/89 │ │
│ │HISTORY.DBF │ 103 │ 09/16/89 │ │
│ │PERSONS.DBF │ 24271 │ 09/16/89 │ │
│ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
│ │
└───────────────────────────────────────────────────────────────────────────┘
- The next prompt will be to select the type of Append:
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
└──────────────────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 24
- If you are appending from another database (.DBF) then select 'Standard'.
- Select the SDF option if you are appending from a 'flat' ASCII file.
- Select the DELIMITED option if you are appending from a delimited ASCII
file. Delimited files contain records in which the fields are separated by
commas, and its character fields contained in double quotes...
- If you select a Standard Append, you will then be prompted to enter the name
of the database you wish to get the data from. If you selected the SDF or
DELIMITED options, then enter the file name containing the data to be
appended into your target database.
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into PERSONS.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: PERSON1.TXT │
│ │
│ │
└──────────────────────────────────────────────────────────────────────────┘
- The number of records appended into the target database will be displayed
upon completion of the task...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF From INVENTY.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: INVENTY.DBF │
│ │
│ │
│ │
│ There Were 1 Records Appended Into INVENT.DBF │
│ │
│ │
│ │
│ Press Any Key To Continue... │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 25
■ BROWSE DATABASES
- Used to edit/view records in a database. Enter the database name you wish to
edit/browse, or if it exists in the current directory, press enter on an
empty prompt to bring up a window box to select from.
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: INVENT.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
- If there exists an index (.NDX or .NTX), with the same name as the database,
it will be utilized... The DAYO Inventory indexes are the exception. They
are automatically set/used.
- An example of a browse screen:
TJS LAB, PO BOX 585366
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ MFG_PART DESC PRICE LIST │
│──────────────────╥────────────────────────────────╥────────────╥───────────│
│ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │
│ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │
│ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │
│ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │
│ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │
│ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │
│ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │
│ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │
│ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │
│ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │
│ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │
│ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │
│ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │
│ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │
│ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │
│ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │
│ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │
├──────────────────╨────────────────────────────────╨────────────╨───────────┤
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
51/60
DAYO Price Book, TJS LAB Page: 26
- To edit a memo field, just highlight the field, and start typing.
* * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING!
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ PRICE LIST YOURPART NOTES │
│───────────────────────╥────────────╥─────────────────╥─────────────────────│
│ 896.16 ║ 1792.32 ║ ║ <Memo> │
│ 1064.19 ║ 2128.38 ║ ║ <Memo> │
│ 672.12 ║ 1344.24 ║ ║ <Memo> │
│ 1736.31 ║ 3472.62 ║ ║ <Memo> │
│ 504.09 ║ 1008.18 ║ ║ <Memo> │
│ 784.14 ║ 1568.28 ║ ║ <Memo> │
│ 1400.25 ║ 2800.50 ║ ║ <Memo> │
┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐
│You can edit memo fields too... │
│ │
│ │
│ │
│ │
│ │
│ │
└───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
- Special keys for 'moving around' the BROWSE screen are:
Left Arrow Key - Move to next field to your left
Right Arrow Key - Move to next field to your right
Ctrl Home - Go to the leftmost field
Ctrl End - Go to the rightmost field (on the end of the record)
Up Arrow - Move highlight to the previous record
Down Arrow - Move highlight to the next record
PgUp - Page up a full screen of records
PgDn - Page down a full screen of records
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end or last record of the file
Ctrl N - Add a record (where applicable)
Ctrl U - Delete a record (where applicable)
F5 - To seek/find a record based upon the active index
Esc - Exit the current operation
- Remember that there are many more fields to the right of the screen. Press
the right arrow key to view them...
DAYO Price Book, TJS LAB Page: 27
■ COPY (.DBF) TO
- Copy records to another (new) database. Use this option to copy select
records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can
also be used to create backups of data (EG: copy to floppy).
┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │HARPS.DBF │ 375 │ 09/16/89 │ │
│ │INVENT.DBF │ 7335 │ 09/16/89 │ │
│ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │
│ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │
│ │AP.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
└────────────────────────────────────────────────────────────────────────────┘
- The next prompt will be to select the type of COPY TO option you want:
┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: INVENT.DBF │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ │
│ Copy Records From INVENT.DBF │
└────────────────────────────────────────────────────────────────────────────┘
- The Standard option is simply creating another database (.DBF). The SDF and
DELIMITED options will create ASCII files. The STRUCTURE option creates a
new database with the same file structure as the initial database (no
records copied).
DAYO Price Book, TJS LAB Page: 28
- The next prompt (optional), requires some knowledge of dBase (tm). This
prompt is requesting the user to enter a condition or filter. If all
records are to be copied, just press Enter on an empty prompt.
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW.DBF │
│ │
│ Enter Condition: │
│ Sample condition: COST > 100 │
│ │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
- This 'Condition' option is useful for coping only specific records into a
new location. Any valid dBase/Clipper statement (as shown next) is
fine...
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW DBF │
│ │
│ Enter Condition: PRICE>0 │
│ Sample condition: COST > 100 │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 29
- The following window message will appear while the COPY TO routine does
its task:
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW10 │
│ │
│ Enter Condition: PRICE>0 │
│ Sample cond┌───────────────────────────────────────────────┐ │
│ │┌─────────────────────────────────────────────┐│ │
│ CONDITION: ││┌───────────────────────────────────────────┐││ │
│ │││┌─────────────────────────────────────────┐│││ │
│ ││││Hold those camels while I do this COPY TO││││ │
│ │││└─────────────────────────────────────────┘│││ │
│ ││└───────────────────────────────────────────┘││ │
│ │└─────────────────────────────────────────────┘│ │
│ └───────────────────────────────────────────────┘ │
│ Copy Records From SDF To NEW10 │
└────────────────────────────────────────────────────────────────────────────┘
■ CREATE DATABASE
- Create a new database. This routine lets you create entirely new database
structures. At the FIELD_NAME field, enter a unique field name. At the
FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date,
'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the
size/length of the character and/or numeric field. At the FIELD_DEC field,
enter the number of decimals for the numeric field.
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ ║ ║ 0 ║ 0 │
│ ║ ║ ║ │
│ ║ ║ ║ │
┌─────────────│ ║ ║ ║ │────────────┐
│ │ ║ ║ ║ │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
DAYO Price Book, TJS LAB Page: 30
* * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * *
IT IS SLIGHTLY BOTHERSOME
SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING...
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to edit the new database.
This error may even cause your computer to hang!
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ NAME ║ C ║ 30 ║ 0 │
│ AGE ║ N ║ 5 ║ 1 │
│ DEAD ║ L ║ 1 ║ 0 │
│ BIRTHDATE ║ D ║ 8 ║ 0 │
┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐
│ │ ║ ║ 0 ║ 0 │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│ ║ ║ ║ │
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
DAYO Price Book, TJS LAB Page: 31
■ DELETE RECORDS
- Delete selected records from databases. The first prompt is for the name of
the database you wish to mark records for deletion. Like many of the other
routines, you can press enter on an empty prompt to bring up all databases
that exist in the current directory:
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│D.DBF │ 259 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/16/89 │
│XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└────────────────────────────────────────────────────────────────────────────┘
- After selecting the database, all its fields will be presented atop the
screen so as to aid the user in entering a condition/filter. The use of the
condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax
is required. Note the use of the Clipper Function: EMPTY().
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐
│ Enter Database Name: TRASH │
│ Delete Records For Condition: EMPTY(PART) │
│ Sample condition: COST > 100 │
│ CONDITION: EMPTY(PART) │
│ Number of Records Deleted: 208 │
│ Press any key to continue... │
└────────────────────────────────────────────────────────────────────────────┘
- The number of records deleted will be displayed upon the screen as depicted
just above...
DAYO Price Book, TJS LAB Page: 32
■ ERASE FILE
- Erase a file (forever!). Use this option with extreme care!
Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY
REMOVED FROM EXISTENCE
NO SECOND CHANCES HERE...
- The first prompt is for the file name. You can press enter on an empty
prompt to bring up a window selection of all files in the current directory.
┌────────────────────────┐
┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘
│BKDOOR.DOC │ 37029 │ 09/17/89 │
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│D.DBF │ 259 │ 09/16/89 │
│D.DBT │ 512 │ 09/16/89 │
│DAYOBK.BAK │ 36879 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
│DAYOBK.OBJ │ 35585 │ 09/16/89 │
│DAYOCAL.MAP │ 35 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│DDD.DBT │ 512 │ 09/16/89 │
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
- To ERASE a file, just highlight it, then press Enter...
■ EXIT TO DOS
- This option will close all open files and databases and exit to DOS without
having to return to the main menu exit routine.
DAYO Price Book, TJS LAB Page: 33
■ INDEX A DATABASE
- You will be prompted to select the database you wish to index. After
selecting the database, by typing in the name or pressing Enter on an empty
prompt (then selecting from the window), you will be given a listing of all
fields in that database atop the screen.
┌────────[ PICK A DATABASE ]───────────┐.
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DAD.DBF │ 259 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SPW.DBF │ 7335 │ 09/16/89 │
│SOW.DBF │ 103 │ 09/16/89 │
│BOY.DBF │ 24387 │ 09/17/89 │
│SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
- You will now be prompted to enter the name of the Index File. It will be
(by default), named exactly the same as the selected database, with the
exception of the extension. This will default to .NDX or .NTX depending on
whether you linked NDX.OBJ with your application.
*** Remember that the BROWSE routine only looks at indexes with the same
name as the database.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
└───────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 34
- At the prompt for the index key, enter a field name, or a valid
dBase/Clipper expression.
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
│ Enter the Key Expression: PART+MFG_PART │
└───────────────────────────────────────────────────────────────┘
■ LIST FIELDS
- List fields to screen or printer. This routine is a great tool for providing
simple reports and lists. The first prompt will be for the database you wish
to work with. Type the name of the file, or press Enter on an empty prompt
to bring up a window of all databases in the current directory for
selection.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│INVEND.DBF │ 259 │ 09/16/89 │
│INVENT.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SOMEDAY.DBF │ 7335 │ 09/16/89 │
│TANGO.DBF │ 103 │ 09/16/89 │
│AP.DBF │ 24387 │ 09/17/89 │
│BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 35
- The next prompt is for a condition or filter. This makes it possible to list
only specific records that meet that condition you enter. The condition must
be a valid dBase/Clipper expression, or none (to list all).
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌─────────────────────────────────────────────────────┐
│ Enter Filter: │
│ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
└─────────────────────────────────────────────────────┘
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: │
│ │
└───────────────────────────────────────────────────────────────┘
- A window box appears next displaying all the fields in the selected database
and an option to list all fields. Highlight any combination of fields ( or
ALL) that you want listed.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║ ├─────────────────┤ ║
╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝
│RECNO() │
│MFG_PART │
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 36
- The fields you select will be displayed at center top of screen. Press Esc
to exit the "PICK THE FIELDS YOU WANT LISTED" window.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
- At the next prompt, you can send the list to the SCREEN, PRINTER OR
FILE.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│DESC┌──────────────────────────────────────────────────────────────────┐
│PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │
│LIST│ │
│YOUR└──────────────────────────────────────────────────────────────────┘─┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 37
- The list is very simple, and if displayed onto the screen, may look like the
following:
PART MFG_PART PRICE
4523 0.00
DAYO9S 41926 1904.34
DAYO10S 13564 616.11
DAYOCOMP 45625 2072.37
DAYOALLS 43159 1960.35
INDEXER 50558 2296.41
INDEXERS 51791 2352.42
5 DEMO 4932 224.04
DAYO13S 20963 952.17
MENUS 53024 2408.43
OFFSITEP 56724 2576.46
ONSITEP 57957 2632.47
DAYO2S 24662 1120.20
DAYO9 40693 1848.33
DAYO10 12331 560.10
DAYOCAL$ 44392 2016.36
DAYO13 19730 896.16
DAYO2 23429 1064.19
DAYO11 14797 672.12
DAYO8 38227 1736.31
DAYO1 11098 504.09
DAYO12 17264 784.14
DAYO5 30828 1400.25
......PRESS ANY KEY TO CONTINUE......
■ MODIFY DATABASE
- Change the fields/structure of a database. You can add new fields, delete
fields, change the length and type of field in any of the databases. At the
FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter
a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M'
for memofield. At the FIELD_LEN field, enter the size/length of the
character and/or numeric field. At the FIELD_DEC field, enter the number of
decimals for the numeric field.
********************************************************
*** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST ***
*** IT IS SLIGHTLY BOTHERSOME SORRY! ***
********************************************************
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to access the database.
This error may even cause your computer to hang!
DAYO Price Book, TJS LAB Page: 38
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
■ PACK DATABASE
- Pack a database (removed deleted records). This option will permanently
remove any records marked for deletion. This is another routine you should
use with great care! As in many of the other of the routines, you will be
prompted to enter the name of the database you wish to pack. Enter the name
or press Enter on an empty prompt to view the window.
┌─────┐
│PACK!│
└─────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│GOODDATA.DBF │ 259 │ 09/16/89 │
│HAP.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│LOIN.DBF │ 103 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/17/89 │
│FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
- After selecting the database, you will be prompted to respond with a Yes or
No (to Pack or not to Pack...). This is the last chance you have to change
your mind...
┌──────────────────────────────────────────────────────────────────────────┐
│ PACK TOM3 │
│ Are you sure you want to PACK (remove deleted records) ? N │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 39
■ RECALL RECORDS
- Recalls records previously marked for deletion. This option is identical to
the DELETE RECORDS option discussed earlier...
■ RETURN TO MENU
- Returns to the procedure that called MISC Routines.
■ RUN (DOS COMMAND)
- Run a DOS command (EG: dir/w). This option is helpful in that it allows
you to run programs at the DOS level (within memory constraints).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN CD\DOS │
└───────────────────────────────────────────────────────────────────────────┘
- One useful option is to type and Enter: COMMAND at this prompt. You will be
running another DOS Shell totally out of the program (it still is in memory
though).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN COMMAND │
└───────────────────────────────────────────────────────────────────────────┘
- Press and Enter: EXIT to return to your Clipper Application.
EG:
The COMPAQ Personal Computer MS-DOS
Version 3.31
(C) Copyright Compaq Computer Corp. 1982, 1987
(C) Copyright Microsoft Corp. 1981, 1987
C:\KISBBS>EXIT
DAYO Price Book, TJS LAB Page: 40
■ SIMPLE EDITOR
- A simple editor and word processor. Use this option to create and read
simple TEXT files. File size is limited to your machines capabilities or
32,000k. The first prompt is for the name of the file you wish to edit. Type
in the name, or press Enter on an empty prompt to bring up a window option
box containing all files in the current directory.
┌────────────────────────┐
┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐
│ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │
│ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │
└────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
│DEMO.MAP │ 7780 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
- *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...),
so be careful at what you select for viewing/editing.
- If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those
changes. If you exit with an Esc, all changes will be lost!
┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐
│CLIPPER demo │
│CLIPPER MISC │
│KWAIT 10 │
│LIB MISC-+MISC,MISC.LST,MISC │
│KWAIT 10 │
│TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │
│KWAIT 10 │
│DEMO │
└────────────────────────────────────────────────────────────────────────────┘
Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0
DAYO Price Book, TJS LAB Page: 41
- Special keys for 'moving around' the SIMPLE EDITOR screen are:
Left Arrow Key - Move to your left
Right Arrow Key - Move to your right
Ctrl Home - Go to the top, leftmost corner of window
Ctrl End - Go to the bottom, rightmost corner of window
Up Arrow - Move up one line
Down Arrow - Move down one line
PgUp - Page up a full screen
PgDn - Page down a full screen
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end of the file
* F2 - Import text from a text file
* Ctrl W - Save Changes and Exit
* Esc - ABORT Changes and Exit
The margin may exceed the boundaries on the right side of the screen, but
the text is easily accessed using the special keys above...
■ SORT DATABASE
- This option takes a database, sorts it, and copies the result into a new
database. The first prompt is for the name of the database you want to sort.
Enter the name, or press Enter on an empty prompt to bring up a window box
containing all databases in the current directory.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DOG.DBF │ 259 │ 09/16/89 │
│CAT.DBF │ 375 │ 09/16/89 │
│CAR.DBF │ 195 │ 09/17/89 │
│BAM.DBF │ 7335 │ 09/16/89 │
│HARP.DBF │ 103 │ 09/17/89 │
│TRAIN.DBF │ 24387 │ 09/17/89 │
│HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└───────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 42
- The next prompt is for the name of the database you will be creating with
the sorted data.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: INVNET.DBF │
│ Enter Name of Sorted File: INVNET1.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
- The next prompt is for the sort field (limited to 1 field)...
╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: TOM.DBF │
│ Enter Name of Sorted File: TOM1.DBF │
│ Enter the Key Expression: PART │
└───────────────────────────────────────────────────────────────┘
■ TYPE (PRINT) FILE
- Prints an ASCII/text file to screen or printer. The first prompt is for the
file name.
┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐
│ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │
│ Press Enter/Return on an empty field to get a current directory listing. │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 43
- The display of the file (any type), is continuous, but can be paused by
any key (except the Enter & Esc keys). Pressing the Enter key will slow the
printing of the file onto the screen. Press Esc to Abort the display... A
sample display:
FUNCKEY...........MISC FUNIQUE...........MISC
FZAP..............MISC GET_PIC1..........MISC
ISDATA............MISC ISDBF.............MISC
MENU_KEY..........MISC MISC..............MISC
OKFILE............MISC PACKIT............MISC
PICKDBF...........MISC PROCLIST..........MISC
SHOW_INS2.........MISC STATLINE2.........MISC
TOG_INS2..........MISC XKEY_CLEAR........MISC
XKEY_NORM.........MISC XMEMO.............MISC
MISC
BKDOOR BROWSEIT CENTER1 COLORSET
DBFUNCT DBFUNCT6 EDITOR FACHOICE
FAPPEND FCOPY2 FDBF1 FDELETE
FERASE FILESZ FILE_UDF FILT
FINDER FINDEX FMAKEDB FMODYDB
FNEW FRECALL FRUN FSCROLL1
FSORT FTYPEIT FUNCKEY FUNIQUE
FZAP GET_PIC1 ISDATA ISDBF
MENU_KEY MISC OKFILE PACKIT
PICKDBF PROCLIST SHOW_INS2 STATLINE2
TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO
PRESS ANY KEY TO CONTINUE...
■ ZAP DATABASE
- Totally erase all records in database (forever!). When you
want to remove every record from a database, then use this option. Use with
EXTREME CAUTION! The first prompt is for the file name. Enter the name of
the database you are to 'clean out', or press Enter to select the database
from a window containing all databases in the current directory.
DAYO Price Book, TJS LAB Page: 44
┌────┐
│ZAP!│
└────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DENVER.DBF │ 259 │ 09/16/89 │
│OHIO.DBF │ 375 │ 09/16/89 │
│NEWYORK.DBF │ 195 │ 09/17/89 │
│MONTANA.DBF │ 7335 │ 09/16/89 │
│SC.DBF │ 259 │ 09/17/89 │
│EARS.DBF │ 103 │ 09/17/89 │
│FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐
│MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │
│CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │
└──────────────┴────────────┴──────────┘───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
- You will be prompted one last time as to whether you still want to ZAP the
selected database. Press Y for Yes, N for No...
┌────┐
│ZAP!│
└────┘
┌──────────────────────────────────────────────────────────────────────────┐
│ ZAP TRASH │
│ Are you sure you want to ZAP (remove all records permanently) ? N │
│ │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 45
■ HELP SCREENS
- While in the browse screens, some of the option windows, and in the SIMPLE
EDITOR, pressing the F1 key, will display a help screen.
- BROWSE help:
┌──────────────────────[ DAYOPB HELP: DBEDIT, 0, ]──────────────────────────┐
│ │
│- Special keys for 'moving around' the BROWSE screen are: │
│ │
│ Left Arrow Key - Move to next field to your left │
│ Right Arrow Key - Move to next field to your right │
│ Ctrl Home - Go to the leftmost field │
│ Ctrl End - Go to the rightmost field (on the end of the record)│
│ Up Arrow - Move highlight to the previous record │
│ Down Arrow - Move highlight to the next record │
│ PgUp - Page up a full screen of records │
│ PgDn - Page down a full screen of records │
│ Ctrl PgUp - Go to the beginning of the file │
│ Ctrl PgDn - Go to the end or last record of the file │
│ Ctrl N - Add a record (where applicable) │
│ Ctrl U - Delete a record (where applicable) │
│ F5,F6,F7 - To seek/find a record based upon the active index │
│ Esc - Exit the current operation │
│ │
│ Remember that there are many more fields to the right of the screen. │
│ Press the right arrow key to view them... │
└────────────────────────────────────────────────────────────────────────────┘
- Option Box Help:
┌───────────────────────[ DAYOPB HELP: ACHOICE, 0, ]────────────────────────┐
│ │
│ │
│ │
│ │
│ - Special keys for 'moving around' the Option Box are: │
│ │
│ Up Arrow - Move up one option │
│ Down Arrow - Move down one option │
│ PgUp - Page up multiple records │
│ PgDn - Page down multiple records │
│ Esc - ABORT and Exit │
│ │
│ │
│ After highlighting the option you desire, press Enter... │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Price Book, TJS LAB Page: 46
- Editor help:
┌──────────────────────[ DAYOPB HELP: MEMOEDIT, 0, ]────────────────────────┐
│ │
│ - Special keys for 'moving around' the EDITOR screen are: │
│ │
│ Left Arrow Key - Move to your left │
│ Right Arrow Key - Move to your right │
│ Ctrl Home - Go to the top, leftmost corner of window │
│ Ctrl End - Go to the bottom, rightmost corner of window │
│ Up Arrow - Move up one line │
│ Down Arrow - Move down one line │
│ PgUp - Page up a full screen │
│ PgDn - Page down a full screen │
│ Ctrl PgUp - Go to the beginning of the file │
│ Ctrl PgDn - Go to the end of the file │
│ Ctrl W - SAVE Changes and Exit │
│ Esc - ABORT Changes and Exit │
│ F2 - Import another text file into your document │
│ │
│ The margin may exceed the boundaries on the right side of the screen, │
│ but the text is easily accessed using the special keys above... │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
■ EXPANDED HELP
After Version 1.3, expanded help routines were added to all DAYO modules.
At almost all prompts and menus you can press F1 for help. Help can be a
function key message as displayed on previous page, a message that you have
created (user defined & inputted), or the ability to read the documentation
on the screen (saves paper).
DAYO Price Book, TJS LAB Page: 47
■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
If you press F1 and no user defined & inputted message exists for that
section of the program you are currently in you will receive a message to
this effect, and then a blank/empty screen.
The editing keys for this option are the same as for the Simple Editor
(previous page).
DAYO Price Books Version 4.0 TJS LAB ┌───[February 1991]──┐
┌──────[ DAYO HELP Called by Program: DAYOPB Variable: OPT ]───────┐
│ │
│ │
│ │
│ │
│ │
│ │
│ ╔════════════════════════════════════════════════════════╗ │
│ ║ No Online Help Messages Exist for this prompt... ║ │
│ ║ ║ │
│ ║ You can type in any help message you wish, or ║ │
│ ║ press F1 to view the document for DAYOPB. ║ │
│ ║ ║ │
│ ║ ║ │
│ ║ Press any key to continue... ║ │
│ ╚════════════════════════════════════════════════════════╝ │
│ │
│ │
├───────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │
└───────────────────────────────────────────────────────────────────────────┘
If you wish to input anything at this point, just type whatever you
wish, remembering to press Ctrl W to save all changes. Pressing Esc will
not save ANY changes ( all effort you put into writing a help message will
be lost! ).
DAYO Price Book, TJS LAB Page: 48
DAYO Price Books Version 4.0 TJS LAB ┌───[February 1991]──┐
┌───────[ DAYO HELP Called by Program: DAYOPB Variable: OPT ]───────┐
│ │
│ │
│ │
│ │
│ Type in anything you wish about this portion of the program! │
│ │
│ The length of this file can be many pages... │
│ │
│ Be sure to press Ctrl W to save any changes/additions you make to this │
│ screen. │
│ │
│ │
│ │
│ │
│ │
│ │
├────────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │
└────────────────────────────────────────────────────────────────────────────┘
■ VIEW DOCUMENTATION ONSCREEN
To view the documentation for the module you are in, it must first exist
in the current directory. Document files are named the same as the module,
and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOPB.DOC.
Press F1 in the User Defined & Inputted Help Message screen to display the
document (user manual). The special keys in this option are displayed in the
Help Screen (press F1 again) for this option:
╔══════════════════════════════════════════════════════════════════════════╗
║ While viewing the document for DAYOPB the keyboard is configured ║
║ as followed: ║
║ ║
║ Esc Exit ║
║ F5 Find a string. This search is not case sensitive ║
║ Examples: PAGE: 50 ║
║ INTRODUCTION ║
║ REPORTS ║
║ Home Return to the beginning of the document ║
║ End Go to the bottom of the document ║
║ PgUp Page up ║
║ ║
║ Any other key moves acts like PgDn (page down) ║
║ ║
║ Press any key to continue... ║
╚══════════════════════════════════════════════════════════════════════════╝
DAYO Price Book, TJS LAB Page: 49
■ DATABASE STRUCTURES
Database: PB.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 CUSTOMER Numeric 6 1 6
2 ITEM Character 12 7 18
3 PRICE Numeric 10 2 19 28
───── ────────── ───────── ───── ─── ───── ───
Total 29
Database: INV.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 ITEM Character 12 1 12
2 DESC Character 30 13 42
3 ONHAND Numeric 7 43 49
4 ONORDER Numeric 7 50 56
5 BO Numeric 7 57 63
6 SOLDPTD Numeric 7 64 70
7 SOLDYTD Numeric 7 71 77
8 VENDITEM Character 12 78 89
9 VENDOR Character 10 90 99
10 DATE Date 8 100 107
11 LASTDATE Date 8 108 115
12 COST Numeric 10 2 116 125
13 RETAIL Numeric 10 2 126 135
14 PRICE Numeric 10 2 136 145
15 STOCKLEVEL Numeric 7 146 152
16 TYPE Character 3 153 155
17 CLASS Character 3 156 158
18 TAXABLE Logical 1 159 159
19 SERIALNO Logical 1 160 160
20 WEIGHT Numeric 8 2 161 168
21 UNIT Character 3 169 171
22 LOCATION Character 3 172 174
───── ────────── ───────── ───── ─── ───── ───
Total 175
DAYO Price Book, TJS LAB Page: 50
Database: CUSTOMER.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 CUSTOMER Numeric 6 1 6
2 NAME Character 30 7 36
3 ATTN Character 30 37 66
4 ADDR1 Character 30 67 96
5 ADDR2 Character 30 97 126
6 CITY Character 22 127 148
7 STATE Character 2 149 150
8 ZIP Character 10 151 160
9 SHIPNAME Character 30 161 190
10 SHIPADDR1 Character 30 191 220
11 SHIPADDR2 Character 30 221 250
12 SHIPCITY Character 22 251 272
13 SHIPSTATE Character 2 273 274
14 SHIPZIP Character 10 275 284
15 PHONE Character 14 285 298
16 SALESPER Character 3 299 301
17 TAXRATE Numeric 5 3 302 306
18 TERMS Character 20 307 326
19 SHIPPER Character 20 327 346
20 DATE Date 8 347 354
21 LASTDATE Date 8 355 362
22 TYPE Character 3 363 365
23 CLASS Character 3 366 368
24 PBM Numeric 6 3 369 374
25 PBL Numeric 6 3 375 380
26 SALESPTD Numeric 10 2 381 390
27 SALESYTD Numeric 10 2 391 400
28 DUE Numeric 10 2 401 410
29 PAID_PURC Numeric 10 2 411 420
30 LIMIT Numeric 10 2 421 430
31 ACTIVE Logical 1 431 431
───── ────────── ───────── ───── ─── ───── ───
Total 432
DAYO Price Book, TJS LAB Page: 51
■ DATA DICTIONARY
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
ACTIVE L 1 0 CUSTOMER.DBF Not used
ADDR1 C 30 0 CUSTOMER.DBF 1st line of the customers address
ADDR2 C 30 0 CUSTOMER.DBF 2nd line of the customers address
ATTN C 30 0 CUSTOMER.DBF Name of the customer contact/POC
BO N 7 0 INV.DBF Quantity (ordered by the customer)
that you have not 'filled'
CITY C 22 0 CUSTOMER.DBF Customers city
CLASS C 3 0 CUSTOMER.DBF Your customer classification code
INV.DBF Item classification code
COST N 10 2 INV.DBF Cost to you from the vendor
CUSTOMER N 6 0 CUSTOMER.DBF Customer number
PB.DBF
DATE D 8 0 CUSTOMER.DBF Date the record was created
INV.DBF
DESC C 30 0 INV.DBF Description of the item
DUE N 10 2 CUSTOMER.DBF Balance Due for products purchased
ITEM C 12 0 INV.DBF Item (product/part) number
PB.DBF
LASTDATE D 8 0 CUSTOMER.DBF Date of last transaction
INV.DBF
LIMIT N 10 2 CUSTOMER.DBF Credit limit
LOCATION C 3 0 INV.DBF Inventory location (Bin)
NAME C 30 0 CUSTOMER.DBF 'Bill To' Name of the Customer
ONHAND N 7 0 INV.DBF Quantity physically in the
main warehouse
ONORDER N 7 0 INV.DBF Quantity on order from vendors
PAID_PURC N 10 2 CUSTOMER.DBF Amount collect for invoices
PBM N 6 3 CUSTOMER.DBF Price Book Margin Points
PBL N 6 3 CUSTOMER.DBF Price Book Discount of List
PHONE C 14 0 CUSTOMER.DBF Customer/client Telephone number
PRICE N 10 2 INV.DBF Cost to the customer/client
PB.DBF
RETAIL N 10 2 INV.DBF Suggested manufacturers selling
price
SALESPER C 3 0 CUSTOMER.DBF Sales person responsible for the
SALESPTD N 10 2 CUSTOMER.DBF Total sales this period
SALESYTD N 10 2 CUSTOMER.DBF Total sales this year
SERIALNO L 1 0 INV.DBF Serial numbered item flag
SHIPADDR1 C 30 0 CUSTOMER.DBF Ship To address line 1
SHIPADDR2 C 30 0 CUSTOMER.DBF Ship To address line 2
SHIPCITY C 17 0 CUSTOMER.DBF Ship To city
SHIPNAME C 30 0 CUSTOMER.DBF Ship To name
SHIPPER C 20 0 CUSTOMER.DBF Shipper/method of shipment
SHIPSTATE C 2 0 CUSTOMER.DBF Ship To state
SHIPZIP C 10 0 CUSTOMER.DBF Ship To zip code
SOLDPTD N 7 0 INV.DBF Period to Date quantity sold
DAYO Price Book, TJS LAB Page: 52
SOLDYTD N 7 0 INV.DBF Year to Date quantity sold
STOCKLEVEL N 7 0 INV.DBF Stocking Level
STATE C 2 0 CUSTOMER.DBF Customers state
TAXABLE L 1 0 INV.DBF Flag to charge customer taxes
TAXRATE N 5 3 CUSTOMER.DBF Tax rate to be charged a customer/
TERMS C 20 0 CUSTOMER.DBF Method of payment for invoices
TYPE C 3 0 CUSTOMER.DBF Type of invoice
INV.DBF Type of item
UNIT C 3 0 INV.DBF Unit of issue (ie: EA, KIT, BOX)
VENDITEM C 12 0 INV.DBF Vendor or Manufacturer Item or
product number
VENDOR C 10 0 INV.DBF Vendor code
WEIGHT N 8 2 INV.DBF Weight of an item. User determines
the standard (ie: lbs or Kilos)
ZIP C 10 0 CUSTOMER.DBF Customers zip code
■ DAYO PRICE BOOK MAINTENANCE & QUIRKS
- On occasion (maybe an under statement), index files will get corrupted,
especially on networks. To 'fix' a corrupted index requires that everyone
'get out of' the DAYO databases, and then perform a reindexing (actually a
recreation of the indexes). The reindex is accomplished by running the DAYO
Price Book program with a parameter of 'INDEX' (or using DAYO X).
ie:
C:\>DAYOPB INDEX
- If you are on a multiuser network, you must 'flag' (change file attributes)
of all files to make them sharable, readable and writable. Note that the
command/program 'flag' may be called by a different name on your network.
ie:
E:\>FLAG *.NTX SRW
or just to be safe, go ahead and flag all files in the directory:
E:\>FLAG *.* SRW
DAYO Price Book, TJS LAB Page: 53
- Indexes are recreated once every day. This is automatically performed by the
first user to run DAYO Price Book. This process will take more time as your
files get larger. This process should take place daily, but you can run it
at night with a batch file that waits until after midnight (ie: DAYO Clock),
or a with most scheduling programs. All other users and computers must be
out of the databases, or the procedure will not occur properly. Remember to
'flag' the files sharable, readable and writable.
- Backups of your data and configuration files should take place daily! You
have no doubt heard many scare stories. They are all true! The key files
that need to be backed up all have the extension of .DBF, and .CFG. The
.DBF files are your databases. The .CFG file(s) contain your configuration
information (as seen in the Configuration module).
- If you are on a network, it is NOT recommended that you use dBase III+ with
the databases. It may write an end of file marker not always recognized by
DAYO. Appending additional records to the database after this point often
leads/creates a 'bad record' in the database.
- If you must use dBase with DAYO Price Book, be sure to SET EXCLUSIVE OFF
before you open ANY databases. This will allow the opened databases to be
shared, and more importantly, prevent a user (or all users!) from
'crashing'!
- If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files, then
do not use it... Hope to fix this 'feature' with the next upgrade...
DAYO Price Book, TJS LAB Page: 54
■ TJS 'Computer' LAB
TJS LAB is an association of programmers and technicians that produce
customized, multiuser software for the PC based network (ie: Novell and
others). Our specialties include Inventory Control, PC Communications/EDI,
Management, Reports (standard and graphic), Data Conversions, and
Accounting (A/R, A/P).
A unique feature of TJS LAB is that our software is by default, multiuser.
'Standalone' applications are the exception! All our applications are
written in Clipper, Basic, or C (preferably Basic or Clipper). We will
license all our application source codes. We produce applications that work,
are easy to use, and are inexpensive!
Want a change?
Want an enhancement!
Want a completely new product/application?
Want to make your idea a reality?
Custom/contract programming, by TJS LAB, and our associates is available.
Standard rate is $50.00 per hour (our sites). Guaranteed quality and timely
work is our number one policy.
We make program enhancements/changes/fixes at our location(s), but can/do
make 'house calls' via special software and a modem.
Write us at:
TJS LAB
PO Box 585366
Orlando, Florida 32858-5366
Or call us (8:00 am - 5:00 pm):
(407) 291-3960
* Note that TJS LAB, nor any of the associates accept/take any support
calls for unregistered products.